Views [dbo].[vSoaGroupSummaryOrganization]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Schema BoundYes
Created9:36:22 PM Wednesday, August 24, 2011
Last Modified9:36:22 PM Wednesday, August 24, 2011
Columns
Name
Cluster Key PK_vSoaGroupSummaryOrganization: GroupIdGroupId
ParentEntityTypeName
ParentEntityId
GroupClassId
Name
Indexes Indexes
NameColumnsUnique
Cluster Key PK_vSoaGroupSummaryOrganization: GroupIdPK_vSoaGroupSummaryOrganizationGroupId
Yes
SQL Script

CREATE VIEW [dbo].[vSoaGroupSummaryOrganization]
WITH SCHEMABINDING
AS
    SELECT  'ORGRELATIONSHIP-' + [n].[ID] AS [GroupId],
            'Party' AS [ParentEntityTypeName],
            [n].[ID] AS [ParentEntityId],
            'ORGRELATIONSHIP' AS [GroupClassId],
            [n].[COMPANY] AS [Name]
      FROM  [dbo].[Name] AS [n]
     WHERE  [n].[COMPANY_RECORD] = 1

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupSummaryOrganization] ON [dbo].[vSoaGroupSummaryOrganization] ([GroupId]) ON [PRIMARY]
GO
Uses
Used By